USE NutritionTracker
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'NavigationMenu') AND type in (N'U'))
	DROP TABLE NavigationMenu
GO
CREATE TABLE NavigationMenu
(
	NavMenuID	TINYINT IDENTITY(1,1) NOT NULL,
	ParentNavMenuID	TINYINT NULL,
	NavMenuName	NVARCHAR(50) NOT NULL,
	NavURL	VARCHAR(200) NOT NULL,
	SortOrder	TINYINT NOT NULL CONSTRAINT df_NavigationMenu_SortOrder DEFAULT 0,
	CONSTRAINT pk_NavigationMenu PRIMARY KEY(NavMenuID ASC)
)
GO